SELECT Id FROM new_searchtable
where (town like 'Lyme' and state='NH'
or town like 'Enfield' and state='NH'
or town like 'Lebanon' and state='NH'
or town like 'Hanover' and state='NH'
or town like 'Plainfield'and state='NH'
or town like 'Cornish'and state='NH'
or town like 'Grantham'and state='NH'
or town like 'Eastman'and state='NH'
or town like 'Dorchester'and state='NH' )
and list_price > '700000' and type ='L'
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Dartmouth Area Luxury NH Land / Acres page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:16.6 acres boasting a private setting with abundant wildlife and scenic foreground, with potential long range views. Just four miles from Dartmouth College and downtown Hanover, this idyllic Stevens Road property sits high above the town with a potential for exceptional south and westerly views with clearing. Your private hilltop retreat and endless possibilities await.
Description:An exceptional 238 wooded acres located conveniently off of I89. Between exits 13 and 14, this location is close to the Dartmouth and Lake Sunapee Regions. Here’s your opportunity to own a substantial piece of New Hampshire. Ground Lease on property for Cell Tower. 3 day right of first refusal.
Description:Located at the strategic intersection of RT 89 Southbound Exit 13 and RT 10 South, this expansive 13.4-acre tract offers an unparalleled opportunity for development. Previously engineered for a 100-room hotel, the site includes detailed plans and drawings, showcasing its potential. Situated directly across from Sawyer Brook Plaza and a Mobil station, the property benefits from substantial daily traffic, with AADT counts reaching 6,794 on RT 10 South and 18,701 on I89 South. This commercial land is zoned for versatile use, allowing for a variety of development projects subject to approval. Key features include a high-yield well and necessary provisions for a bridge to maximize access and utilization. Just 20 minutes from Dartmouth Hitchcock Medical Center and Mount Sunapee Resort, and a two-hour drive from Boston, MA, the site is ideally positioned to cater to both local and tourist traffic. Don’t miss out on this prime piece of real estate, ready for a visionary development.
Description:INCREDIBLE VIEWS OF MASCOMA LAKE - This enchanting property has it all, brooks and streams and meadows and forests! Build your secluded Upper Valley dream home, subdivide and fulfill many family's dreams, or start that cross country equestrian center you've always dreamed of. The historic barn is an incredible resource for massive beams and boards. Situated close to Dartmouth Hitchcock Medical Center, Dartmouth College, Vermont Law School, Colby-Sawyer College, Green Mountain Horse Association, shopping, skiing.
Description:Amazing opportunity to build your dream home on the Connecticut River. 12.3 acres, comprised of three lots, that stretch along the river bank. The property includes a charming island that is home to many birds, you'll often see a pair of eagles that love to watch the river from their perch high above the water. Rolling fields, with two high points and a path leading to a beach with easy access for boating, swimming or paddle boarding. On the southern crest two Adirondack chairs provide the perfect spot to watch the river and work out which river view you want to wake up to. Imagine the possibilities!